class CreateIssues < ActiveRecord::Migration
  def self.up
    create_table :issues do |t|
      t.integer               :issueid
      t.string                :priority
      t.integer               :P1
      t.integer               :P2
      t.integer               :R
      t.integer               :S
      t.text                  :step
      t.string                :title
      t.text                  :description
      t.string                :ratio
      t.string                :card_type
      t.string                :phoneid
      t.string                :state
      t.date                  :actually_time_spent
      t.references            :project, :null => false

      t.timestamps
    end

    add_index "issues", ["project_id"], :name => "index_issues_on_project_id"

  end

  def self.down
    drop_table :issues
  end
end
